KeyFinder: An Efficient Minimal Keys Finding Algorithm For Relational Databases

نویسندگان

چکیده

In relational databases, it is essential to know all minimal keys since the concept of database normaliza-tion based on and functional dependencies a relation schema. Existing algorithms for determining keysor computing closure arbitrary sets attributes are generally time-consuming. this paper we present anefficient algorithm, called KeyFinder, solving key-finding problem. We also propose more direct methodfor set attributes. KeyFinder powerful proof procedure findingkeys tableaux. Experimental results show that outperforms its predecessors in terms searchspace execution time.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Relational Databases Query Optimization using Hybrid Evolutionary Algorithm

Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...

متن کامل

Relational Databases in RDF: Keys and Foreign Keys

Today, most of the data on the web resides in relational databases. To make the data available for the semantic web mappings into RDF can be used. Such mappings should preserve the information about the structure of keys and foreign keys, because otherwise important semantic information is lost. In this paper, we discuss several possible ways to map relational databases into an RDF graph. We di...

متن کامل

Error-Correcting Keys in Relational Databases

Suppose that the entries of a relational database are collected in an unreliable way, that is the actual database may differ from the true database in at most one data of each individual. An error-correcting key is such a set of attributes, that the knowledge of the actual data of an individual in this set of attributes uniquely determines the individual. It is showed that if the minimal keys a...

متن کامل

The Number of Keys in Relational and Nested Relational Databases

Thalheim, B., The number of keys in relational and nested relational databases, Discrete Applied Mathematics 40 (1992) 265-282. Combinatorial propositions, concerning the maximal number of minimal keys are considered. It is shown that the results of Demetrovics about the maximal number of minimal keys on unbounded domains do not hold for finite domains. Using this result lower bounds for the si...

متن کامل

Finding Minimal Keys in a Relation Instance

Mannila 11] cites as an open problem in Data Mining the problem of nding all minimal keys in a relation instance using only time that is polynomial in the number of relation attributes and number of minimal keys and sub-quadratic in the size of the relation instance. This paper investigates the eecacy of an \A Priori"-type approach to the problem, applied simultaneously in a level-wise top-down...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

ژورنال

عنوان ژورنال: Inteligencia artificial

سال: 2021

ISSN: ['1988-3064', '1137-3601']

DOI: https://doi.org/10.4114/intartif.vol24iss68pp37-52